﻿<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="EventDataSet" targetNamespace="http://tempuri.org/EventDataSet.xsd" xmlns:mstns="http://tempuri.org/EventDataSet.xsd" xmlns="http://tempuri.org/EventDataSet.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
  <xs:annotation>
    <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
      <DataSource DefaultConnectionIndex="0" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
        <Connections>
          <Connection AppSettingsObjectName="Settings" AppSettingsPropertyName="DataConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="DataConnectionString (Settings)" PropertyReference="ApplicationSettings.AssData.Properties.Settings.GlobalReference.Default.DataConnectionString" Provider="System.Data.OleDb" />
        </Connections>
        <Tables>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="EventTableAdapter" GeneratorDataComponentClassName="EventTableAdapter" Name="Event" UserDataComponentName="EventTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="DataConnectionString (Settings)" DbObjectName="Event" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetAllData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetAllData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetAllData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM `Event` WHERE ((`ID` = ?) AND ((? = 1 AND `UniqueSN` IS NULL) OR (`UniqueSN` = ?)) AND ((? = 1 AND `EventTitle` IS NULL) OR (`EventTitle` = ?)) AND ((? = 1 AND `EventMark` IS NULL) OR (`EventMark` = ?)) AND ((? = 1 AND `EventRelate` IS NULL) OR (`EventRelate` = ?)) AND ((? = 1 AND `EventLocation` IS NULL) OR (`EventLocation` = ?)) AND ((? = 1 AND `EventStartime` IS NULL) OR (`EventStartime` = ?)) AND ((? = 1 AND `EventEndtime` IS NULL) OR (`EventEndtime` = ?)) AND ((? = 1 AND `EventState` IS NULL) OR (`EventState` = ?)) AND ((? = 1 AND `EventAddDate` IS NULL) OR (`EventAddDate` = ?)) AND ((? = 1 AND `AheadOfSchedule` IS NULL) OR (`AheadOfSchedule` = ?)) AND ((? = 1 AND `DuplicateEvent` IS NULL) OR (`DuplicateEvent` = ?)) AND ((? = 1 AND `AllDayEvent` IS NULL) OR (`AllDayEvent` = ?)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_ID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_UniqueSN" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="UniqueSN" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_UniqueSN" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="UniqueSN" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_EventTitle" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="EventTitle" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_EventTitle" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="EventTitle" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_EventMark" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="EventMark" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_EventMark" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="EventMark" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_EventRelate" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="EventRelate" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_EventRelate" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="EventRelate" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_EventLocation" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="EventLocation" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_EventLocation" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="EventLocation" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_EventStartime" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="EventStartime" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="Original_EventStartime" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="EventStartime" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_EventEndtime" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="EventEndtime" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="Original_EventEndtime" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="EventEndtime" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_EventState" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="EventState" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_EventState" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="EventState" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_EventAddDate" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="EventAddDate" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="Original_EventAddDate" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="EventAddDate" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_AheadOfSchedule" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="AheadOfSchedule" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_AheadOfSchedule" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="AheadOfSchedule" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_DuplicateEvent" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="DuplicateEvent" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_DuplicateEvent" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="DuplicateEvent" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_AllDayEvent" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="AllDayEvent" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="Original_AllDayEvent" Precision="0" ProviderType="Boolean" Scale="0" Size="0" SourceColumn="AllDayEvent" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO `Event` (`UniqueSN`, `EventTitle`, `EventMark`, `EventRelate`, `EventLocation`, `EventStartime`, `EventEndtime`, `EventState`, `EventAddDate`, `AheadOfSchedule`, `DuplicateEvent`, `AllDayEvent`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="UniqueSN" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="UniqueSN" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="EventTitle" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="EventTitle" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="EventMark" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="EventMark" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="EventRelate" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="EventRelate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="EventLocation" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="EventLocation" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="EventStartime" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="EventStartime" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="EventEndtime" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="EventEndtime" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="EventState" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="EventState" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="EventAddDate" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="EventAddDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="AheadOfSchedule" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="AheadOfSchedule" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="DuplicateEvent" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="DuplicateEvent" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="AllDayEvent" Precision="0" ProviderType="Boolean" Scale="0" Size="0" SourceColumn="AllDayEvent" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT   ID, UniqueSN, EventTitle, EventMark, EventRelate, EventLocation, EventStartime, EventEndtime, EventState, 
                EventAddDate, AheadOfSchedule, DuplicateEvent, AllDayEvent
FROM      Event
ORDER BY EventStartime</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE `Event` SET `UniqueSN` = ?, `EventTitle` = ?, `EventMark` = ?, `EventRelate` = ?, `EventLocation` = ?, `EventStartime` = ?, `EventEndtime` = ?, `EventState` = ?, `EventAddDate` = ?, `AheadOfSchedule` = ?, `DuplicateEvent` = ?, `AllDayEvent` = ? WHERE ((`ID` = ?) AND ((? = 1 AND `UniqueSN` IS NULL) OR (`UniqueSN` = ?)) AND ((? = 1 AND `EventTitle` IS NULL) OR (`EventTitle` = ?)) AND ((? = 1 AND `EventMark` IS NULL) OR (`EventMark` = ?)) AND ((? = 1 AND `EventRelate` IS NULL) OR (`EventRelate` = ?)) AND ((? = 1 AND `EventLocation` IS NULL) OR (`EventLocation` = ?)) AND ((? = 1 AND `EventStartime` IS NULL) OR (`EventStartime` = ?)) AND ((? = 1 AND `EventEndtime` IS NULL) OR (`EventEndtime` = ?)) AND ((? = 1 AND `EventState` IS NULL) OR (`EventState` = ?)) AND ((? = 1 AND `EventAddDate` IS NULL) OR (`EventAddDate` = ?)) AND ((? = 1 AND `AheadOfSchedule` IS NULL) OR (`AheadOfSchedule` = ?)) AND ((? = 1 AND `DuplicateEvent` IS NULL) OR (`DuplicateEvent` = ?)) AND ((? = 1 AND `AllDayEvent` IS NULL) OR (`AllDayEvent` = ?)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="UniqueSN" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="UniqueSN" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="EventTitle" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="EventTitle" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="EventMark" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="EventMark" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="EventRelate" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="EventRelate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="EventLocation" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="EventLocation" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="EventStartime" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="EventStartime" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="EventEndtime" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="EventEndtime" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="EventState" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="EventState" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="EventAddDate" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="EventAddDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="AheadOfSchedule" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="AheadOfSchedule" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="DuplicateEvent" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="DuplicateEvent" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="AllDayEvent" Precision="0" ProviderType="Boolean" Scale="0" Size="0" SourceColumn="AllDayEvent" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_ID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_UniqueSN" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="UniqueSN" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_UniqueSN" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="UniqueSN" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_EventTitle" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="EventTitle" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_EventTitle" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="EventTitle" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_EventMark" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="EventMark" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_EventMark" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="EventMark" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_EventRelate" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="EventRelate" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_EventRelate" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="EventRelate" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_EventLocation" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="EventLocation" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_EventLocation" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="EventLocation" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_EventStartime" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="EventStartime" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="Original_EventStartime" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="EventStartime" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_EventEndtime" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="EventEndtime" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="Original_EventEndtime" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="EventEndtime" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_EventState" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="EventState" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_EventState" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="EventState" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_EventAddDate" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="EventAddDate" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="Original_EventAddDate" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="EventAddDate" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_AheadOfSchedule" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="AheadOfSchedule" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_AheadOfSchedule" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="AheadOfSchedule" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_DuplicateEvent" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="DuplicateEvent" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_DuplicateEvent" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="DuplicateEvent" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_AllDayEvent" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="AllDayEvent" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="Original_AllDayEvent" Precision="0" ProviderType="Boolean" Scale="0" Size="0" SourceColumn="AllDayEvent" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ID" DataSetColumn="ID" />
              <Mapping SourceColumn="UniqueSN" DataSetColumn="UniqueSN" />
              <Mapping SourceColumn="EventTitle" DataSetColumn="EventTitle" />
              <Mapping SourceColumn="EventMark" DataSetColumn="EventMark" />
              <Mapping SourceColumn="EventRelate" DataSetColumn="EventRelate" />
              <Mapping SourceColumn="EventLocation" DataSetColumn="EventLocation" />
              <Mapping SourceColumn="EventStartime" DataSetColumn="EventStartime" />
              <Mapping SourceColumn="EventEndtime" DataSetColumn="EventEndtime" />
              <Mapping SourceColumn="EventState" DataSetColumn="EventState" />
              <Mapping SourceColumn="EventAddDate" DataSetColumn="EventAddDate" />
              <Mapping SourceColumn="AheadOfSchedule" DataSetColumn="AheadOfSchedule" />
              <Mapping SourceColumn="DuplicateEvent" DataSetColumn="DuplicateEvent" />
              <Mapping SourceColumn="AllDayEvent" DataSetColumn="AllDayEvent" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="DataConnectionString (Settings)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorSourceName="DeleteEvent" Modifier="Public" Name="DeleteEvent" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy" UserSourceName="DeleteEvent">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>DELETE FROM Event
WHERE   (ID = ?) OR
                (UniqueSN = ?)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="Param1" ColumnName="ID" DataSourceName="Event" DataTypeServer="DbType.Int32" DbType="Int32" Direction="Input" ParameterName="ID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Param2" ColumnName="UniqueSN" DataSourceName="Event" DataTypeServer="DbType.StringFixedLength(255)" DbType="String" Direction="Input" ParameterName="UniqueSN" Precision="0" ProviderType="WChar" Scale="0" Size="255" SourceColumn="UniqueSN" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
              </DbSource>
              <DbSource ConnectionRef="DataConnectionString (Settings)" DbObjectName="Event" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByDate" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetEventByDate" GeneratorSourceName="FillByDate" GetMethodModifier="Public" GetMethodName="GetEventByDate" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetEventByDate" UserSourceName="FillByDate">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT AheadOfSchedule, AllDayEvent, DuplicateEvent, EventAddDate, EventEndtime, EventLocation, EventMark, EventRelate, EventStartime, EventState, EventTitle, ID, UniqueSN FROM Event WHERE (EventStartime BETWEEN ? AND ?) OR (EventEndtime BETWEEN ? AND ?) ORDER BY EventStartime</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="Param1" ColumnName="EventStartime" DataSourceName="Event" DataTypeServer="DbType.Date" DbType="Date" Direction="Input" ParameterName="EventStartime" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="EventStartime" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Param2" ColumnName="EventStartime" DataSourceName="Event" DataTypeServer="DbType.Date" DbType="Date" Direction="Input" ParameterName="EventStartime1" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="EventStartime" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Param3" ColumnName="EventEndtime" DataSourceName="Event" DataTypeServer="DbType.Date" DbType="Date" Direction="Input" ParameterName="EventEndtime" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="EventEndtime" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Param4" ColumnName="EventEndtime" DataSourceName="Event" DataTypeServer="DbType.Date" DbType="Date" Direction="Input" ParameterName="EventEndtime1" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="EventEndtime" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="DataConnectionString (Settings)" DbObjectName="Event" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByEvent" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetAlertEvent" GeneratorSourceName="FillByEvent" GetMethodModifier="Public" GetMethodName="GetAlertEvent" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetAlertEvent" UserSourceName="FillByEvent">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT   ID, UniqueSN, EventTitle, EventMark, EventRelate, EventLocation, EventStartime, EventEndtime, EventState, 
                EventAddDate, AheadOfSchedule, DuplicateEvent, AllDayEvent
FROM      Event
WHERE   (EventState = 0)
ORDER BY EventStartime</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="DataConnectionString (Settings)" DbObjectName="Event" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillBysingleEvent" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataByID" GeneratorSourceName="FillBysingleEvent" GetMethodModifier="Public" GetMethodName="GetDataByID" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataByID" UserSourceName="FillBysingleEvent">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT AheadOfSchedule, AllDayEvent, DuplicateEvent, EventAddDate, EventEndtime, EventLocation, EventMark, EventRelate, EventStartime, EventState, EventTitle, ID, UniqueSN FROM Event WHERE (ID = ?) OR (UniqueSN = ?) ORDER BY EventStartime DESC</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="Param1" ColumnName="ID" DataSourceName="Event" DataTypeServer="DbType.Int32" DbType="Int32" Direction="Input" ParameterName="ID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Param2" ColumnName="UniqueSN" DataSourceName="Event" DataTypeServer="DbType.StringFixedLength(255)" DbType="String" Direction="Input" ParameterName="UniqueSN" Precision="0" ProviderType="WChar" Scale="0" Size="255" SourceColumn="UniqueSN" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="DataConnectionString (Settings)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorSourceName="InsertEvent" Modifier="Public" Name="InsertEvent" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy1" UserSourceName="InsertEvent">
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>INSERT INTO Event
                (UniqueSN, EventTitle, EventMark, EventRelate, EventLocation, EventStartime, EventEndtime, EventState, 
                EventAddDate, AheadOfSchedule, DuplicateEvent, AllDayEvent)
VALUES   (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="Param1" ColumnName="UniqueSN" DataSourceName="Event" DataTypeServer="DbType.StringFixedLength(255)" DbType="String" Direction="Input" ParameterName="UniqueSN" Precision="0" ProviderType="WChar" Scale="0" Size="255" SourceColumn="UniqueSN" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Param2" ColumnName="EventTitle" DataSourceName="Event" DataTypeServer="DbType.StringFixedLength(255)" DbType="String" Direction="Input" ParameterName="EventTitle" Precision="0" ProviderType="WChar" Scale="0" Size="255" SourceColumn="EventTitle" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Param3" ColumnName="EventMark" DataSourceName="Event" DataTypeServer="DbType.StringFixedLength(255)" DbType="String" Direction="Input" ParameterName="EventMark" Precision="0" ProviderType="WChar" Scale="0" Size="255" SourceColumn="EventMark" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Param4" ColumnName="EventRelate" DataSourceName="Event" DataTypeServer="DbType.StringFixedLength(255)" DbType="String" Direction="Input" ParameterName="EventRelate" Precision="0" ProviderType="WChar" Scale="0" Size="255" SourceColumn="EventRelate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Param5" ColumnName="EventLocation" DataSourceName="Event" DataTypeServer="DbType.StringFixedLength(255)" DbType="String" Direction="Input" ParameterName="EventLocation" Precision="0" ProviderType="WChar" Scale="0" Size="255" SourceColumn="EventLocation" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Param6" ColumnName="EventStartime" DataSourceName="Event" DataTypeServer="DbType.Date" DbType="Date" Direction="Input" ParameterName="EventStartime" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="EventStartime" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Param7" ColumnName="EventEndtime" DataSourceName="Event" DataTypeServer="DbType.Date" DbType="Date" Direction="Input" ParameterName="EventEndtime" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="EventEndtime" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Param8" ColumnName="EventState" DataSourceName="Event" DataTypeServer="DbType.StringFixedLength(255)" DbType="String" Direction="Input" ParameterName="EventState" Precision="0" ProviderType="WChar" Scale="0" Size="255" SourceColumn="EventState" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Param9" ColumnName="EventAddDate" DataSourceName="Event" DataTypeServer="DbType.Date" DbType="Date" Direction="Input" ParameterName="EventAddDate" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="EventAddDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Param10" ColumnName="AheadOfSchedule" DataSourceName="Event" DataTypeServer="DbType.Int32" DbType="Int32" Direction="Input" ParameterName="AheadOfSchedule" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="AheadOfSchedule" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Param11" ColumnName="DuplicateEvent" DataSourceName="Event" DataTypeServer="DbType.StringFixedLength(255)" DbType="String" Direction="Input" ParameterName="DuplicateEvent" Precision="0" ProviderType="WChar" Scale="0" Size="255" SourceColumn="DuplicateEvent" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Param12" ColumnName="AllDayEvent" DataSourceName="Event" DataTypeServer="DbType.Boolean(2)" DbType="Boolean" Direction="Input" ParameterName="AllDayEvent" Precision="0" ProviderType="Boolean" Scale="0" Size="2" SourceColumn="AllDayEvent" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
              </DbSource>
              <DbSource ConnectionRef="DataConnectionString (Settings)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorSourceName="UpdateEvent" Modifier="Public" Name="UpdateEvent" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy2" UserSourceName="UpdateEvent">
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>UPDATE  Event
SET         EventTitle = ?, EventMark = ?, EventRelate = ?, EventLocation = ?, EventStartime = ?, EventEndtime = ?, EventState = ?, 
                EventAddDate = ?, AheadOfSchedule = ?, DuplicateEvent = ?, AllDayEvent = ?
WHERE   (ID = ?) OR
                (UniqueSN = ?)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="Param1" ColumnName="EventTitle" DataSourceName="Event" DataTypeServer="DbType.StringFixedLength(255)" DbType="String" Direction="Input" ParameterName="EventTitle" Precision="0" ProviderType="WChar" Scale="0" Size="255" SourceColumn="EventTitle" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Param2" ColumnName="EventMark" DataSourceName="Event" DataTypeServer="DbType.StringFixedLength(255)" DbType="String" Direction="Input" ParameterName="EventMark" Precision="0" ProviderType="WChar" Scale="0" Size="255" SourceColumn="EventMark" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Param3" ColumnName="EventRelate" DataSourceName="Event" DataTypeServer="DbType.StringFixedLength(255)" DbType="String" Direction="Input" ParameterName="EventRelate" Precision="0" ProviderType="WChar" Scale="0" Size="255" SourceColumn="EventRelate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Param4" ColumnName="EventLocation" DataSourceName="Event" DataTypeServer="DbType.StringFixedLength(255)" DbType="String" Direction="Input" ParameterName="EventLocation" Precision="0" ProviderType="WChar" Scale="0" Size="255" SourceColumn="EventLocation" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Param5" ColumnName="EventStartime" DataSourceName="Event" DataTypeServer="DbType.Date" DbType="Date" Direction="Input" ParameterName="EventStartime" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="EventStartime" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Param6" ColumnName="EventEndtime" DataSourceName="Event" DataTypeServer="DbType.Date" DbType="Date" Direction="Input" ParameterName="EventEndtime" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="EventEndtime" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Param7" ColumnName="EventState" DataSourceName="Event" DataTypeServer="DbType.StringFixedLength(255)" DbType="String" Direction="Input" ParameterName="EventState" Precision="0" ProviderType="WChar" Scale="0" Size="255" SourceColumn="EventState" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Param8" ColumnName="EventAddDate" DataSourceName="Event" DataTypeServer="DbType.Date" DbType="Date" Direction="Input" ParameterName="EventAddDate" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="EventAddDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Param9" ColumnName="AheadOfSchedule" DataSourceName="Event" DataTypeServer="DbType.Int32" DbType="Int32" Direction="Input" ParameterName="AheadOfSchedule" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="AheadOfSchedule" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Param10" ColumnName="DuplicateEvent" DataSourceName="Event" DataTypeServer="DbType.StringFixedLength(255)" DbType="String" Direction="Input" ParameterName="DuplicateEvent" Precision="0" ProviderType="WChar" Scale="0" Size="255" SourceColumn="DuplicateEvent" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Param11" ColumnName="AllDayEvent" DataSourceName="Event" DataTypeServer="DbType.Boolean(2)" DbType="Boolean" Direction="Input" ParameterName="AllDayEvent" Precision="0" ProviderType="Boolean" Scale="0" Size="2" SourceColumn="AllDayEvent" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="Param12" ColumnName="ID" DataSourceName="Event" DataTypeServer="DbType.Int32" DbType="Int32" Direction="Input" ParameterName="Original_ID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Param13" ColumnName="UniqueSN" DataSourceName="Event" DataTypeServer="DbType.StringFixedLength(255)" DbType="String" Direction="Input" ParameterName="Original_UniqueSN" Precision="0" ProviderType="WChar" Scale="0" Size="255" SourceColumn="UniqueSN" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="SettingTableAdapter" GeneratorDataComponentClassName="SettingTableAdapter" Name="Setting" UserDataComponentName="SettingTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="DataConnectionString (Settings)" DbObjectName="Setting" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM `Setting` WHERE ((`ID` = ?) AND ((? = 1 AND `Theme` IS NULL) OR (`Theme` = ?)) AND ((? = 1 AND `AutoStart` IS NULL) OR (`AutoStart` = ?)) AND ((? = 1 AND `AutoSkin` IS NULL) OR (`AutoSkin` = ?)) AND ((? = 1 AND `AlertMid` IS NULL) OR (`AlertMid` = ?)) AND ((? = 1 AND `AlertSpan` IS NULL) OR (`AlertSpan` = ?)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_ID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Theme" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Theme" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_Theme" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Theme" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_AutoStart" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="AutoStart" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="Original_AutoStart" Precision="0" ProviderType="Boolean" Scale="0" Size="0" SourceColumn="AutoStart" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_AutoSkin" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="AutoSkin" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="Original_AutoSkin" Precision="0" ProviderType="Boolean" Scale="0" Size="0" SourceColumn="AutoSkin" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_AlertMid" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="AlertMid" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_AlertMid" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="AlertMid" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_AlertSpan" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="AlertSpan" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_AlertSpan" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="AlertSpan" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO `Setting` (`Theme`, `AutoStart`, `AutoSkin`, `AlertMid`, `AlertSpan`) VALUES (?, ?, ?, ?, ?)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Theme" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Theme" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="AutoStart" Precision="0" ProviderType="Boolean" Scale="0" Size="0" SourceColumn="AutoStart" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="AutoSkin" Precision="0" ProviderType="Boolean" Scale="0" Size="0" SourceColumn="AutoSkin" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="AlertMid" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="AlertMid" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="AlertSpan" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="AlertSpan" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT ID, Theme, AutoStart, AutoSkin, AlertMid, AlertSpan FROM Setting</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE `Setting` SET `Theme` = ?, `AutoStart` = ?, `AutoSkin` = ?, `AlertMid` = ?, `AlertSpan` = ? WHERE ((`ID` = ?) AND ((? = 1 AND `Theme` IS NULL) OR (`Theme` = ?)) AND ((? = 1 AND `AutoStart` IS NULL) OR (`AutoStart` = ?)) AND ((? = 1 AND `AutoSkin` IS NULL) OR (`AutoSkin` = ?)) AND ((? = 1 AND `AlertMid` IS NULL) OR (`AlertMid` = ?)) AND ((? = 1 AND `AlertSpan` IS NULL) OR (`AlertSpan` = ?)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Theme" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Theme" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="AutoStart" Precision="0" ProviderType="Boolean" Scale="0" Size="0" SourceColumn="AutoStart" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="AutoSkin" Precision="0" ProviderType="Boolean" Scale="0" Size="0" SourceColumn="AutoSkin" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="AlertMid" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="AlertMid" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="AlertSpan" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="AlertSpan" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_ID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Theme" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Theme" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_Theme" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Theme" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_AutoStart" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="AutoStart" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="Original_AutoStart" Precision="0" ProviderType="Boolean" Scale="0" Size="0" SourceColumn="AutoStart" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_AutoSkin" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="AutoSkin" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="Original_AutoSkin" Precision="0" ProviderType="Boolean" Scale="0" Size="0" SourceColumn="AutoSkin" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_AlertMid" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="AlertMid" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_AlertMid" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="AlertMid" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_AlertSpan" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="AlertSpan" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_AlertSpan" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="AlertSpan" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ID" DataSetColumn="ID" />
              <Mapping SourceColumn="Theme" DataSetColumn="Theme" />
              <Mapping SourceColumn="AutoStart" DataSetColumn="AutoStart" />
              <Mapping SourceColumn="AutoSkin" DataSetColumn="AutoSkin" />
              <Mapping SourceColumn="AlertMid" DataSetColumn="AlertMid" />
              <Mapping SourceColumn="AlertSpan" DataSetColumn="AlertSpan" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="DataConnectionString (Settings)" DbObjectName="Setting" DbObjectType="Table" GenerateShortCommands="true" GeneratorSourceName="GetAlertMid" Modifier="Public" Name="GetAlertMid" QueryType="Scalar" ScalarCallRetval="System.String, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy" UserSourceName="GetAlertMid">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT top 1 AlertMid FROM Setting</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="DataConnectionString (Settings)" DbObjectName="Setting" DbObjectType="Table" GenerateShortCommands="true" GeneratorSourceName="GetAlertSpan" Modifier="Public" Name="GetAlertSpan" QueryType="Scalar" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy1" UserSourceName="GetAlertSpan">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT top 1 AlertSpan FROM Setting</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="DataConnectionString (Settings)" DbObjectName="Setting" DbObjectType="Table" GenerateShortCommands="true" GeneratorSourceName="GetAutoSkin" Modifier="Public" Name="GetAutoSkin" QueryType="Scalar" ScalarCallRetval="System.Boolean, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy2" UserSourceName="GetAutoSkin">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT top 1 AutoSkin FROM Setting</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="DataConnectionString (Settings)" DbObjectName="Setting" DbObjectType="Table" GenerateShortCommands="true" GeneratorSourceName="GetAutoStart" Modifier="Public" Name="GetAutoStart" QueryType="Scalar" ScalarCallRetval="System.Boolean, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy3" UserSourceName="GetAutoStart">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT top 1 AutoStart FROM Setting</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="DataConnectionString (Settings)" DbObjectName="Setting" DbObjectType="Table" GenerateShortCommands="true" GeneratorSourceName="GetTheme" Modifier="Public" Name="GetTheme" QueryType="Scalar" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy4" UserSourceName="GetTheme">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT top 1 Theme FROM Setting</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="DataConnectionString (Settings)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorSourceName="UpdateQuery" Modifier="Public" Name="UpdateQuery" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy5" UserSourceName="UpdateQuery">
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>UPDATE `Setting` SET `Theme` = ?, `AutoStart` = ?, `AutoSkin` = ?, `AlertMid` = ?, `AlertSpan` = ? WHERE ((`ID` = 1) </CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="Param1" ColumnName="Theme" DataSourceName="" DataTypeServer="DbType.StringFixedLength(255)" DbType="String" Direction="Input" ParameterName="Theme" Precision="0" ProviderType="WChar" Scale="0" Size="255" SourceColumn="Theme" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="Param2" ColumnName="AutoStart" DataSourceName="" DataTypeServer="DbType.Boolean(2)" DbType="Boolean" Direction="Input" ParameterName="AutoStart" Precision="0" ProviderType="Boolean" Scale="0" Size="2" SourceColumn="AutoStart" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="Param3" ColumnName="AutoSkin" DataSourceName="" DataTypeServer="DbType.Boolean(2)" DbType="Boolean" Direction="Input" ParameterName="AutoSkin" Precision="0" ProviderType="Boolean" Scale="0" Size="2" SourceColumn="AutoSkin" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Param4" ColumnName="AlertMid" DataSourceName="" DataTypeServer="DbType.StringFixedLength(255)" DbType="String" Direction="Input" ParameterName="AlertMid" Precision="0" ProviderType="WChar" Scale="0" Size="255" SourceColumn="AlertMid" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Param5" ColumnName="AlertSpan" DataSourceName="" DataTypeServer="DbType.Int32" DbType="Int32" Direction="Input" ParameterName="AlertSpan" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="AlertSpan" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="Param6" ColumnName="ID" DataSourceName="" DataTypeServer="DbType.Int32" DbType="Int32" Direction="Input" ParameterName="Original_ID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Param7" ColumnName="Theme" DataSourceName="" DataTypeServer="DbType.StringFixedLength(255)" DbType="String" Direction="Input" ParameterName="Original_Theme" Precision="0" ProviderType="WChar" Scale="0" Size="255" SourceColumn="Theme" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Param8" ColumnName="Theme" DataSourceName="" DataTypeServer="DbType.StringFixedLength(255)" DbType="String" Direction="Input" ParameterName="Original_Theme1" Precision="0" ProviderType="WChar" Scale="0" Size="255" SourceColumn="Theme" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="Param9" ColumnName="AutoStart" DataSourceName="" DataTypeServer="DbType.Boolean(2)" DbType="Boolean" Direction="Input" ParameterName="Original_AutoStart" Precision="0" ProviderType="Boolean" Scale="0" Size="2" SourceColumn="AutoStart" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="Param10" ColumnName="AutoStart" DataSourceName="" DataTypeServer="DbType.Boolean(2)" DbType="Boolean" Direction="Input" ParameterName="Original_AutoStart1" Precision="0" ProviderType="Boolean" Scale="0" Size="2" SourceColumn="AutoStart" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="Param11" ColumnName="AutoSkin" DataSourceName="" DataTypeServer="DbType.Boolean(2)" DbType="Boolean" Direction="Input" ParameterName="Original_AutoSkin" Precision="0" ProviderType="Boolean" Scale="0" Size="2" SourceColumn="AutoSkin" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="Param12" ColumnName="AutoSkin" DataSourceName="" DataTypeServer="DbType.Boolean(2)" DbType="Boolean" Direction="Input" ParameterName="Original_AutoSkin1" Precision="0" ProviderType="Boolean" Scale="0" Size="2" SourceColumn="AutoSkin" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Param13" ColumnName="AlertMid" DataSourceName="" DataTypeServer="DbType.StringFixedLength(255)" DbType="String" Direction="Input" ParameterName="Original_AlertMid" Precision="0" ProviderType="WChar" Scale="0" Size="255" SourceColumn="AlertMid" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Param14" ColumnName="AlertMid" DataSourceName="" DataTypeServer="DbType.StringFixedLength(255)" DbType="String" Direction="Input" ParameterName="Original_AlertMid1" Precision="0" ProviderType="WChar" Scale="0" Size="255" SourceColumn="AlertMid" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Param15" ColumnName="AlertSpan" DataSourceName="" DataTypeServer="DbType.Int32" DbType="Int32" Direction="Input" ParameterName="Original_AlertSpan" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="AlertSpan" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Param16" ColumnName="AlertSpan" DataSourceName="" DataTypeServer="DbType.Int32" DbType="Int32" Direction="Input" ParameterName="Original_AlertSpan1" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="AlertSpan" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
        </Tables>
        <Sources />
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="EventDataSet" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:EnableTableAdapterManager="True" msprop:Generator_DataSetName="EventDataSet" msprop:Generator_UserDSName="EventDataSet">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="Event" msprop:Generator_TableClassName="EventDataTable" msprop:Generator_TableVarName="tableEvent" msprop:Generator_RowChangedName="EventRowChanged" msprop:Generator_TablePropName="Event" msprop:Generator_RowDeletingName="EventRowDeleting" msprop:Generator_RowChangingName="EventRowChanging" msprop:Generator_RowEvHandlerName="EventRowChangeEventHandler" msprop:Generator_RowDeletedName="EventRowDeleted" msprop:Generator_RowClassName="EventRow" msprop:Generator_UserTableName="Event" msprop:Generator_RowEvArgName="EventRowChangeEvent">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ID" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnID" msprop:Generator_ColumnPropNameInRow="ID" msprop:Generator_ColumnPropNameInTable="IDColumn" msprop:Generator_UserColumnName="ID" type="xs:int" />
              <xs:element name="UniqueSN" msprop:Generator_ColumnVarNameInTable="columnUniqueSN" msprop:Generator_ColumnPropNameInRow="UniqueSN" msprop:Generator_ColumnPropNameInTable="UniqueSNColumn" msprop:Generator_UserColumnName="UniqueSN" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="EventTitle" msprop:Generator_ColumnVarNameInTable="columnEventTitle" msprop:Generator_ColumnPropNameInRow="EventTitle" msprop:Generator_ColumnPropNameInTable="EventTitleColumn" msprop:Generator_UserColumnName="EventTitle" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="EventMark" msprop:Generator_ColumnVarNameInTable="columnEventMark" msprop:Generator_ColumnPropNameInRow="EventMark" msprop:Generator_ColumnPropNameInTable="EventMarkColumn" msprop:Generator_UserColumnName="EventMark" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="EventRelate" msprop:Generator_ColumnVarNameInTable="columnEventRelate" msprop:Generator_ColumnPropNameInRow="EventRelate" msprop:Generator_ColumnPropNameInTable="EventRelateColumn" msprop:Generator_UserColumnName="EventRelate" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="EventLocation" msprop:Generator_ColumnVarNameInTable="columnEventLocation" msprop:Generator_ColumnPropNameInRow="EventLocation" msprop:Generator_ColumnPropNameInTable="EventLocationColumn" msprop:Generator_UserColumnName="EventLocation" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="EventStartime" msprop:Generator_ColumnVarNameInTable="columnEventStartime" msprop:Generator_ColumnPropNameInRow="EventStartime" msprop:Generator_ColumnPropNameInTable="EventStartimeColumn" msprop:Generator_UserColumnName="EventStartime" type="xs:dateTime" minOccurs="0" />
              <xs:element name="EventEndtime" msprop:Generator_ColumnVarNameInTable="columnEventEndtime" msprop:Generator_ColumnPropNameInRow="EventEndtime" msprop:Generator_ColumnPropNameInTable="EventEndtimeColumn" msprop:Generator_UserColumnName="EventEndtime" type="xs:dateTime" minOccurs="0" />
              <xs:element name="EventState" msprop:Generator_ColumnVarNameInTable="columnEventState" msprop:Generator_ColumnPropNameInRow="EventState" msprop:Generator_ColumnPropNameInTable="EventStateColumn" msprop:Generator_UserColumnName="EventState" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="EventAddDate" msprop:Generator_ColumnVarNameInTable="columnEventAddDate" msprop:Generator_ColumnPropNameInRow="EventAddDate" msprop:Generator_ColumnPropNameInTable="EventAddDateColumn" msprop:Generator_UserColumnName="EventAddDate" type="xs:dateTime" minOccurs="0" />
              <xs:element name="AheadOfSchedule" msprop:Generator_ColumnVarNameInTable="columnAheadOfSchedule" msprop:Generator_ColumnPropNameInRow="AheadOfSchedule" msprop:Generator_ColumnPropNameInTable="AheadOfScheduleColumn" msprop:Generator_UserColumnName="AheadOfSchedule" type="xs:int" minOccurs="0" />
              <xs:element name="DuplicateEvent" msprop:Generator_ColumnVarNameInTable="columnDuplicateEvent" msprop:Generator_ColumnPropNameInRow="DuplicateEvent" msprop:Generator_ColumnPropNameInTable="DuplicateEventColumn" msprop:Generator_UserColumnName="DuplicateEvent" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="AllDayEvent" msprop:Generator_ColumnVarNameInTable="columnAllDayEvent" msprop:Generator_ColumnPropNameInRow="AllDayEvent" msprop:Generator_ColumnPropNameInTable="AllDayEventColumn" msprop:Generator_UserColumnName="AllDayEvent" type="xs:boolean" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Setting" msprop:Generator_TableClassName="SettingDataTable" msprop:Generator_TableVarName="tableSetting" msprop:Generator_RowChangedName="SettingRowChanged" msprop:Generator_TablePropName="Setting" msprop:Generator_RowDeletingName="SettingRowDeleting" msprop:Generator_RowChangingName="SettingRowChanging" msprop:Generator_RowEvHandlerName="SettingRowChangeEventHandler" msprop:Generator_RowDeletedName="SettingRowDeleted" msprop:Generator_RowClassName="SettingRow" msprop:Generator_UserTableName="Setting" msprop:Generator_RowEvArgName="SettingRowChangeEvent">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ID" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnID" msprop:Generator_ColumnPropNameInRow="ID" msprop:Generator_ColumnPropNameInTable="IDColumn" msprop:Generator_UserColumnName="ID" type="xs:int" />
              <xs:element name="Theme" msprop:Generator_ColumnVarNameInTable="columnTheme" msprop:Generator_ColumnPropNameInRow="Theme" msprop:Generator_ColumnPropNameInTable="ThemeColumn" msprop:Generator_UserColumnName="Theme" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="AutoStart" msprop:Generator_ColumnVarNameInTable="columnAutoStart" msprop:Generator_ColumnPropNameInRow="AutoStart" msprop:Generator_ColumnPropNameInTable="AutoStartColumn" msprop:Generator_UserColumnName="AutoStart" type="xs:boolean" minOccurs="0" />
              <xs:element name="AutoSkin" msprop:Generator_ColumnVarNameInTable="columnAutoSkin" msprop:Generator_ColumnPropNameInRow="AutoSkin" msprop:Generator_ColumnPropNameInTable="AutoSkinColumn" msprop:Generator_UserColumnName="AutoSkin" type="xs:boolean" minOccurs="0" />
              <xs:element name="AlertMid" msprop:Generator_ColumnVarNameInTable="columnAlertMid" msprop:Generator_ColumnPropNameInRow="AlertMid" msprop:Generator_ColumnPropNameInTable="AlertMidColumn" msprop:Generator_UserColumnName="AlertMid" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="AlertSpan" msprop:Generator_ColumnVarNameInTable="columnAlertSpan" msprop:Generator_ColumnPropNameInRow="AlertSpan" msprop:Generator_ColumnPropNameInTable="AlertSpanColumn" msprop:Generator_UserColumnName="AlertSpan" type="xs:int" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
    <xs:unique name="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Event" />
      <xs:field xpath="mstns:ID" />
    </xs:unique>
    <xs:unique name="Setting_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Setting" />
      <xs:field xpath="mstns:ID" />
    </xs:unique>
  </xs:element>
</xs:schema>